You are here: 52. Advanced Distribution Training Manual > 52.13. Advanced Stocktake > Automatic Cycle Stocktakes

Automatic Cycle Stocktakes

Micronet 2.8 allows you to setup automatic cycle stocktakes which help to break up the task of counting your stock into manageable stock counting sessions. You can divide up your stock for counting by product category, order class or stocktake class and Micronet will automatically select the items to be counted depending on the total number of items, frequency of stocktakes and number of times each product category, order class or stocktake class is to be counted. In this way, you can conduct stocktaking over as many sessions as required so that every item in the warehouse is counted at least once a year.

For example, you might decide to divide up your stock for counting based on product category, and to do monthly counts with each category counted once a year. Accordingly, you set the stocktake frequency on each product category as one time per year. When you go into Micronet's Stocktake program and create a new batch (which you would do monthly), you select a monthly cycle, base the counts on product category and then create the items in the stocktake batch. Micronet automatically divides the total number of item counts into 12 (counts per year) so that there are 12 equally sized batches. It then displays all the items to be counted this time. You print the stock count sheets, count the stock and enter the counts back into Micronet. Micronet then sets the next stocktake date for each item in the batch as 12 months ahead so that it is not included in another batch until then.

This is a simple example. You can setup automatic stocktakes in much more complex ways. For example, you might want some items to be counted every week (high turnover items or those with frequent variances), others to be counted monthly and yet others to be counted only once a year.

An example will help to illustrate how Micronet selects the items to be counted.

A warehouse has stock of the following items:

Item

Stocktake Frequency

Counts (number of times per year)

A

Weekly

52

B

Weekly

52

C

Weekly

52

D

Fortnightly

26

E

Fortnightly

26

F

Monthly

12

G

Monthly

12

H

Quarterly

4

I

Quarterly

4

J

Annually

1

Because the maximum stocktake frequency is weekly, you need to do weekly stocktakes. The stocktake frequency may be set on the product category, order class or stocktake class.

When you create your first weekly stocktake batch, Micronet totals all the counts - in this case, all the numbers in the Counts column above which add up to 241. It then divides this by the frequency of stocktakes - in this case, weekly which equates to 52.

241 รท 52 = 4.63

Rounding up, this means that Micronet will select 5 items for counting each week.

The items will be selected for counting as follows:

Week 1 / Batch 1

Next stocktake date

Week 2 / Batch 2

Next stocktake date

Week 3 / Batch 3

Next stocktake date

Week 4 / Batch 4

Next stocktake date

Week 5 / Batch 5

Next stocktake date

A

Week 2

A

Week 3

A

Week 4

A

Week 5

A

Week 6

B

Week 2

B

Week 3

B

Week 4

B

Week 5

B

Week 6

C

Week 2

C

Week 3

C

Week 4

C

Week 5

C

Week 6

D

Week 3

F

Week 6

D

Week 5

H

Week 16

D

Week 7

E

Week 3

G

Week 6

E

Week 5

I

Week 16

E

Week 7

From this table, you can see a pattern - the weekly items are counted weekly, the fortnightly items are counted every fortnight, the monthly items will be counted again in Week 6, and so on.

 

Technical Tip

Because Micronet rounds up the number of items for counting, some items might get selected for counting more often than their set stocktake frequency, e.g. some items marked for monthly stocktake might get selected for counting three weeks after their last stocktake date rather than four weeks. This is preferable to items not being counted as often as required.

The following sections explain the planning you need to do before setting up your automatic cycle stocktakes and then how to generate your stocktake batches for counting.